﻿CREATE TABLE [dbo].[ASMS_Station]
(
	[Id] uniqueidentifier NOT NULL PRIMARY KEY,
	[ParentStationId] uniqueidentifier,
	[BusinessId] uniqueidentifier NOT NULL,
	[Number] nvarchar(32) NOT NULL,
	[Name] nvarchar(64) NOT NULL,
	[Telephone] nvarchar(32) NOT NULL,
	[ContactName] nvarchar(32),
	[ContactTelephone] nvarchar(32),
	[QQ] nvarchar(32),
	[Wechat] nvarchar(64),
	[Country] nvarchar(32),
	[Province] nvarchar(32),
	[City] nvarchar(32),
	[District] nvarchar(32),
	[Address] nvarchar(256),
	[PostCode] nvarchar(12),
	[OpenTime] nvarchar(16),
	[CloseTime] nvarchar(16),
	[PreviewImage] nvarchar(256),
	[Status] int NOT NULL,
	[CreatedTime] datetime NOT NULL,
	[Creator] nvarchar(64) NOT NULL
)
